-
- Rate Projections Functions Walkthrough
- Accruals and Cash
- Repeating Formulae
- Range Names and References
- Optional Parameters
- Using PmtsPerYear
- Modelling Seasonality
- Calculating Interest
- Using Business Functions in VBA (Visual Basic for Applications)
- Array Functions
- Volatility
- Annual Equivalent Rates
- Array Function
- Auto Multi Functions
- Variable Plurality
- GoalSeek
- ó3 Digit DayCountó
- Accounts Receivable
- óAccruing Interestó
- óAccruing Interest Periodicó
- óAdvanced Rental Examplesó
- Amortising Loan Shows a simple amortising loan.
- BF and VBA
- Building a Timebase Describes how to use the library to build a timebase of dates and timeperiods for use in business planning and forecasting.
- BusDays And Periods
- Business Plan
- CashBasis-When Cash Moves
- CashBasis In Action
- Cash Mode-When Cash Moves
- Cash Mode In Action
- Composite DayCount
- Date Inclusivity
- Daycount 30360
- Daycount ACT252
- Daycount ACT365
- Daycount ACTACT
- Daycount ACTNL365
- DayCount And Periods
- dbEdit
- óDepreciationó
- Flow of Control
- Holidays
- How Cash Basis Works
- How Cash Periods Work
- LoanAmortisation
- Loan Amortisation with LOANX
- óMonte Carloó
- Multiple Market Rents
- óOilfield Appraisaló The petroleum economics functions are introduced in the form of a field appraisal.
- Operating Budget How to use functions for budgeting operating costs.
- Periods Advance and Arrears
- PrintScript
- óProjecting Rentó
- Project Budget How to use functions for budgeting capital costs.
- óProperty Developmentó Some of the Real Estate functions illustrated in the form of a property appraisal.
- óReal Estate DayCount Exampleó
- óReal Estate Mathó
- óReal Estate Math Comparisonó
- Revenue Functions
- Stepped Revenue Profile Using functions of the Stepped Rate category to project stepping rates over a planning period.
- SyncIns
- Timebases
- tutorial-DCF A review of the different Discounted CashFlow function families in the library. Requires only the Basic Edition.
- tutorial-introduction An introduction to the basics of using the function library, that later goes into the difference between cash and accruals, and the different methods of daycount . Requires only the Basic Edition.
- tutorial-projections A review of the different Projections function families in the library, in the context of budgeting and business planning. Requires only the Basic Edition.
- óVentureCapitaló
Introduction To the Worked Examples | |
Welcome to the Worked Examples Section. Worked Examples are more in-depth than the examples given under each component and try to address realistic industry situations. The examples described are all found in the Business FunctionsWorked Examples directory and are all Excel spreadsheets of course. They can all be accessed from the Business Functions Examples menu. See also the tutorials that are available from the Business Functions menu. The full listing is shown below. The link is to an illustration (preview) of the example. You can access the spreadsheet directly from Excel by browsing to the above-mentioned directory or selecting BusinessFunctions/Examples/Worked Examples/Browse Worked Examples |